Step 3: Connecting to SQL using Java

您所在的位置：网站首页 › java sql › Step 3: Connecting to SQL using Java

Step 3: Connecting to SQL using Java

2024-07-12 20:00| 来源: 网络整理| 查看: 265

Step 3: Proof of concept connecting to SQL using Java Article08/11/2023

This example should be considered a proof of concept only. The sample code is simplified for clarity, and doesn't necessarily represent best practices recommended by Microsoft.

Step 1: Connect

Use the connection class to connect to SQL Database.

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class SQLDatabaseConnection { // Connect to your database. // Replace server name, username, and password with your credentials public static void main(String[] args) { String connectionUrl = "jdbc:sqlserver://yourserver.database.windows.net:1433;" + "database=AdventureWorks;" + "user=yourusername@yourserver;" + "password=yourpassword;" + "encrypt=true;" + "trustServerCertificate=false;" + "loginTimeout=30;"; try (Connection connection = DriverManager.getConnection(connectionUrl);) { // Code here. } // Handle any errors that may have occurred. catch (SQLException e) { e.printStackTrace(); } } } Step 2: Execute a query

In this sample, connect to Azure SQL Database, execute a SELECT statement, and return selected rows.

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class SQLDatabaseConnection { // Connect to your database. // Replace server name, username, and password with your credentials public static void main(String[] args) { String connectionUrl = "jdbc:sqlserver://yourserver.database.windows.net:1433;" + "database=AdventureWorks;" + "user=yourusername@yourserver;" + "password=yourpassword;" + "encrypt=true;" + "trustServerCertificate=false;" + "loginTimeout=30;"; ResultSet resultSet = null; try (Connection connection = DriverManager.getConnection(connectionUrl); Statement statement = connection.createStatement();) { // Create and execute a SELECT SQL statement. String selectSql = "SELECT TOP 10 Title, FirstName, LastName from SalesLT.Customer"; resultSet = statement.executeQuery(selectSql); // Print results from select statement while (resultSet.next()) { System.out.println(resultSet.getString(2) + " " + resultSet.getString(3)); } } catch (SQLException e) { e.printStackTrace(); } } } Step 3: Insert a row

In this example, execute an INSERT statement, pass parameters, and retrieve the autogenerated Primary Key value.

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; public class SQLDatabaseConnection { // Connect to your database. // Replace server name, username, and password with your credentials public static void main(String[] args) { String connectionUrl = "jdbc:sqlserver://yourserver.database.windows.net:1433;" + "database=AdventureWorks;" + "user=yourusername@yourserver;" + "password=yourpassword;" + "encrypt=true;" + "trustServerCertificate=false;" + "loginTimeout=30;"; String insertSql = "INSERT INTO SalesLT.Product (Name, ProductNumber, Color, StandardCost, ListPrice, SellStartDate) VALUES " + "('NewBike', 'BikeNew', 'Blue', 50, 120, '2016-01-01');"; ResultSet resultSet = null; try (Connection connection = DriverManager.getConnection(connectionUrl); PreparedStatement prepsInsertProduct = connection.prepareStatement(insertSql, Statement.RETURN_GENERATED_KEYS);) { prepsInsertProduct.execute(); // Retrieve the generated key from the insert. resultSet = prepsInsertProduct.getGeneratedKeys(); // Print the ID of the inserted row. while (resultSet.next()) { System.out.println("Generated: " + resultSet.getString(1)); } } // Handle any errors that may have occurred. catch (Exception e) { e.printStackTrace(); } } } Also see Sample JDBC driver applications

【本文地址】

Step 3: Connecting to SQL using Java

Step 3: Connecting to SQL using Java

今日新闻

推荐新闻